Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_RULE_SET

`DBA_HIST_RULE_SET` displays historical information about rule set statistics.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SNAP_ID` | `NUMBER` | `NOT NULL` | Unique snapshot ID
`DBID` | `NUMBER` | `NOT NULL` | Database ID for the snapshot
`INSTANCE_NUMBER` | `NUMBER` | `NOT NULL` | Instance number for the snapshot
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the rule set
`NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the rule set
`STARTUP_TIME` | `DATE` | `NOT NULL` | Startup time of the instance
`CPU_TIME` | `NUMBER` |  | Total CPU time (in hundredths of a second) spent in evaluation of the rule set
`ELAPSED_TIME` | `NUMBER` |  | Total elapsed time (in hundredths of a second) spent in evaluation of the rule set
`EVALUATIONS` | `NUMBER` |  | Number of evaluations on the rule set
`SQL_FREE_EVALUATIONS` | `NUMBER` |  | Number of evaluations on the rule set which did not internally issue SQL to evaluate rules
`SQL_EXECUTIONS` | `NUMBER` |  | Total number of SQL statements executed during evaluation of the rule set
`RELOADS` | `NUMBER` |  | Number of times the rule set object was reloaded in shared memory